USE [xRepair]
GO

/****** Object:  StoredProcedure [dbo].[UpdateBrand]    Script Date: 2/22/2014 9:18:41 PM ******/
DROP PROCEDURE [dbo].[UpdateBrand]
GO

/****** Object:  StoredProcedure [dbo].[UpdateBrand]    Script Date: 2/22/2014 9:18:41 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[UpdateBrand]
		 @ID					INT
		,@GenericTypesID		INT	
		,@BrandName				NVARCHAR(200)		
		,@LastUpdatedAt			DATETIME = NULL
		,@LastUpdatedBy			NVARCHAR(50) = NULL
		,@Rowcount				INT = -1 OUTPUT
AS
BEGIN

	SET NOCOUNT ON;

	UPDATE [dbo].[Brand]
	SET [GenericTypesID] =	@GenericTypesID
		,[BrandName]	 =	@BrandName		
		,[LastUpdatedAt] =	@LastUpdatedAt
		,[LastUpdatedBy] =	@LastUpdatedBy
	WHERE [ID] = @ID

    SELECT @Rowcount = @@ROWCOUNT
END



GO


